package JDBC;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBCDemo8 {
    public static void main(String[] args) {
        LoginUserInfo loginUserInfo = InputUtil.getInputObject(new LoginUserInfo());

        try (Connection conn = DBUtil.getConnection();) {
        String sql="SELECT id,username,password,nickname,age " +
                "FROM userinfo " +
                "WHERE username=?" +
                "AND password=? ";

        PreparedStatement ps=conn.prepareStatement(sql);
        ps.setString(1,loginUserInfo.getUsername());
        ps.setString(2,loginUserInfo.getPassword());
        ResultSet rs=ps.executeQuery();
        if(rs.next()){
            String nickname=rs.getString("nickname");
            System.out.println("登录成功，欢迎回来: "+nickname);
        }else {
            System.out.println("登录失败");
        }






        } catch (SQLException e) {
            throw new RuntimeException(e);
        }









    }
}

